package com.pc.tas.export.expfilelist;

import org.apache.ibatis.annotations.*;
import org.apache.ibatis.session.RowBounds;

import java.util.List;

public interface ExpFileListMapper {	
	
	@Insert("insert into t_expfilelist (id,fileName, fileAddress, expType,operatingTime) values (#{id},#{fileName},#{fileAddress},#{expType},#{operatingTime})")
	public int insert(ExpFileList efl);
	
	@Update("update t_expfilelist set fileName = #{fileName}, fileAddress = #{fileAddress}, expType = #{expType},operatingTime = #{operatingTime} where id = #{id}")
	public void update(ExpFileList efl);
	
	@Delete("delete from t_expfilelist where id = #{id}")
	public void delete(int id);
	
	@Select("select * from t_expfilelist where id = #{id}")
	public ExpFileList getById(int id);
	
	@Select("select * from t_expfilelist where exptype=#{exptype} order by id desc")
	public List<ExpFileList> getListByExpType(@Param("exptype") int exptype, RowBounds rowBounds);
}
